package com.lsx143.realtime.common;

/**
 * 用于存放常量
 */
public interface Constants {

    //kafka相关
    String KAFKA_BROKERS = "hadoop162:9092,hadoop163:9092,hadoop164:9092";

    //dwd层表名
    String TOPIC_ODS_LOG = "ods_log";
    String TOPIC_ODS_DB = "ods_db";
    String TOPIC_DWD_START_LOG = "dwd_start_log";
    String TOPIC_DWD_DISPLAY_LOG = "dwd_display_log";
    String TOPIC_DWD_PAGE_LOG = "dwd_page_log";
    String TOPIC_DWD_ORDER_INFO = "dwd_order_info";
    String TOPIC_DWD_ORDER_DETAIL = "dwd_order_detail";
    String TOPIC_DWD_PAYMENT_INFO = "dwd_payment_info";
    String TOPIC_DWD_PAYMENT_DETAIL = "dwd_payment_detail";

    String TOPIC_DWD_FAVOR_INFO = "dwd_favor_info";
    String TOPIC_DWD_CART_INFO = "dwd_cart_info";
    String TOPIC_DWD_REFUND_PAYMENT = "dwd_refund_payment";
    String TOPIC_DWD_COMMENT_INFO = "dwd_comment_info";

    //dwm层表名
    String TOPIC_DWM_UV = "dwm_uv";
    String TOPIC_DWM_JV = "dwm_jv";
    String TOPIC_DWM_ORDER_WIDE = "dwm_order_wide";
    String TOPIC_DWM_PAYMENT_WIDE = "dwm_payment_wide";


    String DIM_USER_INFO = "dim_user_info";
    String DIM_BASE_PROVINCE = "dim_base_province";
    String DIM_BASE_CATEGORY3 = "dim_base_category3";
    String DIM_SKU_INFO = "dim_sku_info";
    String DIM_SPU_INFO = "dim_spu_info";
    String DIM_BASE_TRADEMARK = "dim_base_trademark";

    //动态分流Sink常量
    String SINK_TYPE_HBASE = "hbase";
    String SINK_TYPE_KAFKA = "kafka";
    String SINK_TYPE_CK = "clickhouse";

    /**
     * 驱动配置
     */
    //Phoenix驱动配置
    String PHOENIX_DRIVER = "org.apache.phoenix.jdbc.PhoenixDriver";
    String PHOENIX_URL = "jdbc:phoenix:hadoop162,hadoop163,hadoop164:2181";
    //ClickHouse配置
    String CLICKHOUSE_DRIVER = "ru.yandex.clickhouse.ClickHouseDriver";
    String CLICKHOUSE_URL = "jdbc:clickhouse://hadoop162:8123";
    String CLICKHOUSE_DATABASE = "gmall2021";
    String CLICKHOUSE_TABLE_VISITOR_STATS = "visitor_stats_2021";
    String CLICKHOUSE_TABLE_PRODUCT_STATS = "product_stats_2021";
    String CLICKHOUSE_TABLE_PROVINCE_STATS = "province_stats_2021";
    String CLICKHOUSE_TABLE_KEYWORD_STATS = "keyword_stats_2021";

    //Redis配置
    String REDIS_HOST = "hadoop162";
    Integer REDIS_PORT = 6379;
    //数据过期时间 = 2天
    Integer REDIS_EXPIRE_TIME = 2 * 3600 * 24;

    //好评
    String APPRAISE_GOOD = "1204";
}
